->alias('goods')
->join('uz_z_shop shop', 'goods.shop_id = shop.id')